UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6wRh+jL602O3T7VRFQg8iHIr5bWbcE7hYy8u9H8A6H0='
WHERE
key_id = '361376e21319609a03702c9eb0940f47519fbecc58f0a365d43be371417083dc'
AND (
token = '6wRh+jL602O3T7VRFQg8iHIr5bWbcE7hYy8u9H8A6H0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)