UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qTHk9xN1chIgksEih7ex7ocW593Cetv8RUPdNiTEJiU='
WHERE
key_id = 'bcf15637d2ec882500e1b438874ff1b84b59678a6a7c65cd92fc329983d82b59'
AND (
token = 'qTHk9xN1chIgksEih7ex7ocW593Cetv8RUPdNiTEJiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)