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