UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8Ydy5F+3k1pwkGr8O9/USc7nui6HeXHRDIyKo21t9IE=' 
WHERE 
  key_id = 'a663aa9b1f6c81a56707d30957bba7dc15d08b8b09cec99fe28921145267b5c0' 
  AND (
    token = '8Ydy5F+3k1pwkGr8O9/USc7nui6HeXHRDIyKo21t9IE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048