UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ZezzYtBZYng88Vcvor/EAzU+WaalArkOTyLi8j7yt8='
WHERE
key_id = 'd43a7ef272098138b34007be201ef8f8d19a0a695daf564597e4fd7464562ed6'
AND (
token = '/ZezzYtBZYng88Vcvor/EAzU+WaalArkOTyLi8j7yt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)