UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GCz4wPL2f4fvF3T1AFSuojIb2ZPln7DlOn/dd9d0WGk='
WHERE
key_id = 'c04b7b7d76eae3ec844528a9c77e26967a7edd7b9d53d2e924b985d2b83d1cf4'
AND (
token = 'GCz4wPL2f4fvF3T1AFSuojIb2ZPln7DlOn/dd9d0WGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)