UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sc9B0ATMPBKmxi7U3zF4Khds5Ti2AIaeLzo7AKiYUmM='
WHERE
key_id = '6ac3e3a9e3b58b380333611ef429095b2ce406f17020771e6065fdf45cea9e10'
AND (
token = 'Sc9B0ATMPBKmxi7U3zF4Khds5Ti2AIaeLzo7AKiYUmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)