UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9G2FReZCELNtCMYxAKNobQt1Q141LKXrn2X1IvrpGA='
WHERE
key_id = '9404c411a55acd8992c86125f64a529b43fa2207d196cbbb2f97471bf63a6dc1'
AND (
token = 'H9G2FReZCELNtCMYxAKNobQt1Q141LKXrn2X1IvrpGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)