UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdETr1HvlHe3m6lqQ0uVL1HW+5KjoZ/gSEtS3AxFRTA='
WHERE
key_id = '4391c0ca955152c7ba5005650757dc20e011d660f9534fff1b101697d006fbb5'
AND (
token = 'ZdETr1HvlHe3m6lqQ0uVL1HW+5KjoZ/gSEtS3AxFRTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)