UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mhf5qaO5B0AamWleK8LPwr+HuWRGbynC2i1U6tgEFHg='
WHERE
key_id = 'e377e6408ce4688f61ba9122c7d1d3b1c3fa8ce31e1c5e8a6ece7e4b9185bb28'
AND (
token = 'mhf5qaO5B0AamWleK8LPwr+HuWRGbynC2i1U6tgEFHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)