UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cl5Zu8PoAGPZnTAT/GUHBm/wbTtavN9B6LRX6u2L8X4='
WHERE
key_id = 'c8b4e9206f48d27984a11ec6efd684868fd0a1c88e78551ccfaf7a3cb07f07be'
AND (
token = 'cl5Zu8PoAGPZnTAT/GUHBm/wbTtavN9B6LRX6u2L8X4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)