UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZjGf9vnijkjVRxaalVmRbyYgNlIjyXMGEWDNxtjcsc='
WHERE
key_id = '5597e0288f950e00ba29f96fdfd4a4c05a788680cb7fa0e08620bb489a8000bf'
AND (
token = 'hZjGf9vnijkjVRxaalVmRbyYgNlIjyXMGEWDNxtjcsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)