UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xk5KuJSOwv0TZKl4BDsNQOpV8tVom3sV/v2kuK+byr0='
WHERE
key_id = 'c7df9fc50c85710f97c054c46ec087cfc893ac13d28e0d272a1441c2a40a3309'
AND (
token = 'xk5KuJSOwv0TZKl4BDsNQOpV8tVom3sV/v2kuK+byr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)