UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WU5ivmrJ3tG7XnYv+Ct1h2SNgT8kX4KxAmelAenKxmY='
WHERE
key_id = 'a2e7eb24ae234622094e54b64ad2b0bcb370f9ea4f5aa3e69e3117236c0db9eb'
AND (
token = 'WU5ivmrJ3tG7XnYv+Ct1h2SNgT8kX4KxAmelAenKxmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)