UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZASG8T/b+rWaAfn769w1jdodXaPFJ5kVeTXpKukp1QM='
WHERE
key_id = 'ad196f31332d8437cc33c35c5943e5a95af4cb4c21ac14b9fc34b37d2e6ae490'
AND (
token = 'ZASG8T/b+rWaAfn769w1jdodXaPFJ5kVeTXpKukp1QM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)