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