UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZW0Nv27ji8Wiunevjk7ssJqYU3E1z9izpwHtlKGBpow='
WHERE
key_id = '1ea19026820ed8e584bd099ff95fde6903a183f3f3d68c8333ce8dbcc87d4d21'
AND (
token = 'ZW0Nv27ji8Wiunevjk7ssJqYU3E1z9izpwHtlKGBpow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)