UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9dzJe8uihBx5MAbdPQHVlOSGEZv3I8lAfFKwnhkIG0='
WHERE
key_id = '59bd44cf16de2527bcc536811bd90e1242c12de2e58edf35e1a810bd0dabcb33'
AND (
token = 'd9dzJe8uihBx5MAbdPQHVlOSGEZv3I8lAfFKwnhkIG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)