UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EKA1Vn869W1yxKb2Y9Z4xUNoP86P2V60RpoW6kjSleU='
WHERE
key_id = '24a75fff7368daa3c708121d637710787f16a52bf5373d5dac7c074c139b6415'
AND (
token = 'EKA1Vn869W1yxKb2Y9Z4xUNoP86P2V60RpoW6kjSleU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)