UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QA9H/+AkFXQRmoJQM4KR3+rMZ4puRVHZxrLCBpavBqk='
WHERE
key_id = '5c78e9e248bc3a2ad0458525442f161544a557734c2bbe28e5e286e16ba668bf'
AND (
token = 'QA9H/+AkFXQRmoJQM4KR3+rMZ4puRVHZxrLCBpavBqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)