UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+dv1O8Uu+72w+YeMr6f4kM+FqsOvT85pMb5ZFpg0TVI=' 
WHERE 
  key_id = 'b1f2d0a37fe5728903ac34a819ee4dce680b6f6e8fedbcdc222041af4a73fcfe' 
  AND (
    token = '+dv1O8Uu+72w+YeMr6f4kM+FqsOvT85pMb5ZFpg0TVI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032