UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B0UYuOY9ResXYhj1FWp1shE0vLKJ2q6J4+/yumoh4io='
WHERE
key_id = 'e6f0e4a76610476ab0f630eabf3c0414d820364bb38615fdee6e9b8f87065c2e'
AND (
token = 'B0UYuOY9ResXYhj1FWp1shE0vLKJ2q6J4+/yumoh4io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)