UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hB4Mc7+lcS4jXHvFfiCheYsYEfU0cLbqXz5HjXJxNwM='
WHERE
key_id = 'd4cba5052ed86f53ea1a0757312052373e4f3c9d69ce25c78e8e7bc719db5309'
AND (
token = 'hB4Mc7+lcS4jXHvFfiCheYsYEfU0cLbqXz5HjXJxNwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)