UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+BpK1ojKAw9QVaRUDTPZ9TDlaiZikSssLB8zU+4PXUA=' 
WHERE 
  key_id = '650f6bfad5626cf5381c5b53545221ed43f0815f58f49244233f065cd0d6eafa' 
  AND (
    token = '+BpK1ojKAw9QVaRUDTPZ9TDlaiZikSssLB8zU+4PXUA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026