UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lrZR4b+AvdIAtyMSlOpSerF1HH6N9HfWkPPAcUJDYjA='
WHERE
key_id = '9c32c6c99bd9a8bb1f5421554ae5907edd9272ef257bdc5ec3a3fdee2e7eb339'
AND (
token = 'lrZR4b+AvdIAtyMSlOpSerF1HH6N9HfWkPPAcUJDYjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)