UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UUY6VIe6yThk51Q08j42v0VvI7oKOzbTgPvEAiuxyRQ='
WHERE
key_id = 'e9b9aa3d28a055eb694f6448f66dea0c6ab5997bd78d154fa54a33ab848bec62'
AND (
token = 'UUY6VIe6yThk51Q08j42v0VvI7oKOzbTgPvEAiuxyRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)