UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'viC6PiQqExO/MKlFLZYokJ87d8urmlCH81MKYuvkqoE='
WHERE
key_id = 'd8bd38c5c60e5eccfe9887f6c7bde90c87ff57576eb6856f39889ac6ee805ebf'
AND (
token = 'viC6PiQqExO/MKlFLZYokJ87d8urmlCH81MKYuvkqoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)