UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thr2EKpiachVcsYVGuBhwQxv9HT9PPqJcK4NVJK5UVU='
WHERE
key_id = '305678102b71922a1b1648dbbe48f9c042bbb50426fa2acb32fe7bcd5df162df'
AND (
token = 'thr2EKpiachVcsYVGuBhwQxv9HT9PPqJcK4NVJK5UVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)