UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COHj6Zr3R6cImXhgenxHM7MIKvK4u96X63fSgaBStBU='
WHERE
key_id = '29527ca5b38465ac9fd7f761a77312efdfcac77bb7dbb91797775a39badf3e1a'
AND (
token = 'COHj6Zr3R6cImXhgenxHM7MIKvK4u96X63fSgaBStBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)