UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XL/Hf/g+VDUVrO2c1ImERFTAY/5mmWY98Lt1SIansY0='
WHERE
key_id = 'b665b3efe43655b3f793728e09d1c5886b87ca952ba0f2201178a91fa85bf9a5'
AND (
token = 'XL/Hf/g+VDUVrO2c1ImERFTAY/5mmWY98Lt1SIansY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)