UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XN8c4gB8svhUyfiEP0VFgblUGQEw1sVIGFadPeWX+A='
WHERE
key_id = '5ca023b66ea6d9db2482c27ff28ba8926fff13c44c11a9ee45696b463c12938e'
AND (
token = '9XN8c4gB8svhUyfiEP0VFgblUGQEw1sVIGFadPeWX+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)