UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJY1UX7H8EfHbC6FTYwR5BF9IfLc/VfLJteuwfkPrx4='
WHERE
key_id = 'c9a26f8282cc3762801d18b40dfca40c9ff2a1181f6a17a04c243c242469b430'
AND (
token = 'BJY1UX7H8EfHbC6FTYwR5BF9IfLc/VfLJteuwfkPrx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)