UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qMvyGvds+BkOitt5j+qhDZR3+WP65zuz2btNImX7JtE=' 
WHERE 
  key_id = 'df78b063553d0771aade33ba0d89b63c5155dc27f61e53bbfa3e8135aa8f8faf' 
  AND (
    token = 'qMvyGvds+BkOitt5j+qhDZR3+WP65zuz2btNImX7JtE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034