UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8hM9dPQ1hIV0qO2ZtYic/iJ5pceQz07cSuNRf9zCC/Y='
WHERE
key_id = '4073bcc288490e6cec348d256be6ec4c1dcfd37666f7b8431b504fee55ce1b26'
AND (
token = '8hM9dPQ1hIV0qO2ZtYic/iJ5pceQz07cSuNRf9zCC/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)